package com.work.app.mapper;

import com.work.app.bean.ManageMenu;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 *
 * @description 针对表【manage_menu(业务管理端菜单)】的数据库操作Mapper
 * @Date 2024-05-14 12:06:15
 * @author hjj
 */
@Mapper
public interface ManageMenuMapper extends BaseMapper<ManageMenu> {
    @Select("select * from manage_menu where up_id = #{id} and state in(#{state},3)")
    List<ManageMenu> getSubMenusById(@Param("id") Integer id, @Param("state") Integer state);
    @Select("select * from manage_menu where state in(#{state},3) and up_id = 0")
    List<ManageMenu> getMenusByState(Integer state);
}




